from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class OwnTax(Base):
    __tablename__ = "TYC_MR_OWN_TAX"
    TAXIDNUMBER = Column(String(255))
    NEWOWNTAXBALANCE = Column(String(255))
    OWNTAXAMOUNT = Column(String(255))
    PUBLISHDATE = Column(String(255))
    OWNTAXBALANCE = Column(String(255))
    TYPE = Column(String(255))
    PERSONIDNUMBER = Column(String(255))
    TAXCATEGORY = Column(String(255))
    TAXPAYERTYPE = Column(String(255))
    PERSONIDNAME = Column(String(255))
    NAME = Column(String(255))
    LOCATION = Column(String(255))
    DEPARTMENT = Column(String(255))
    REGTYPE = Column(String(255))
    LEGALPERSONNAME = Column(String(255))

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)